MeasurementType

Entity Definition

Logical Name : MeasurementType
Physical Name : LU_MSRMT_TYP

Identifies, names and defines data warehouse measures that are used, in conjunction with named value ranges, to segment customers based on behavior.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MeasurementTypeCode (PK) Indicates the category of measurement represented by this MeasurementType instance. Valid values include: VOLUME = number of units or a count FREQUENCY = number of occurences in a time period MAGNITUDE = relative size of each unit CD_MSRMT_TYP Code varchar(20)
MeasurementTypeName Business name for the MeasurementType NM_MSRMT_TYP DescriptionShort varchar(255)
MeasurementTypeNarrative Short narrative description of the MeasurementType NA_MSRMT_TYP DescriptionNarrative varchar(4000)

Relationships

Parent Entity Verb Phrase Child Entity
MeasurementType classifies Measurement

No Logical Views for MeasurementType